# ReadMe

These files replicate the results in the following paper: Does project-level foreign aid increase access to improved water sources? Evidence from household panel data in Uganda
By Lynda Pickbourn, Raymond Caraher, and Leonce Ndikumana.


## Instructions

One R script and 2 stata scripts are used to generate the results.
You will have to install the required packages for each language in order to run these scripts.
You will also have to change the base directory for your setup.
By default, tables and figures are written to your-script-path/replication-tables and your_script-path/replication-figures.
You will need to create these folders on your machine to run these scripts.
Or you can change where the files are saved.


### Data

The data is stored in the replication-data folder, and by default the scripts read from your_script-path/replication-data.

1. uga_admbnda_ubos_20200824_shp - contains the Uganada shapefiles needed for the figures

2. aid_by_coords.csv - ODA extract which shows aid projects and their coordinates

3. aid_by_districts.csv - ODA extract which shows aid projects by district

4. unps_gsec_aid_rep_data.dta - Extracts from each wave of the Uganda National Panel Survey, merged with geo-located data on water aid projects from ODA. 

5. variables.xlsx - Description and coding of some variables from the Uganda National Panel Survey.

6. crs_uga_sect_90_20.csv - All ODA to sectors for Uganda from 1990-2020

7. crs_uga_bw_10_20.csv - Basic Water Supply ODA for Uganda from 2010-2020


### Scripts

Run these scripts in the following order:

1. figures-rep.r - R script which generates the figures and some summary statistics
	Specifically, it generates the following tables:1, 2, 3, 4, 5, A2, A4, A5
	It generates the following figures: 1, 2, 3
	

2. regressions.do - Stata script which generate the primary regression results and some summary statistics as well
	Specifically, it generates the following tables: 6, 8, 9, 10, 11, 12, 13, 14, A6 


## Other

Please contact the authors if you would like to view the scripts used to extract the data from the panel surveys.
Note that since confidential information was used to match villages to coordinates and compute aid distances,
we are unable to share that data.

Please contact the authors if you have other questions about the use of this data.




